Database Recovery Using Redundant Disk Arrays

Redundant disk arrays provide a way for achieving rapid recovery from media failures with a relatively low storage cost for large scale database systems requiring high availability. In this paper we propose a method for using redundant disk arrays to support rapid recovery from system crashes and transaction aborts in addition to their role in providing media failure recovery. A twin page scheme is used to store the parity information in the array so that the time for transaction commit processing is not degraded. Using an analytical model, we show that the proposed method achieves a significant increase in the throughput of database systems using redundant disk arrays by reducing the number of recovery operations needed to maintain the consistency of the database. !_,[,y_'r_ A._T _I_,K A_AY,S (illinois Univ ) D N92-257,_9 UriC] ::_s S 31 _,'? 0OV3_0 "This research was supported in part by the National Aeronautics and Space Administration (NASA) under Contract NAG 1-613 and in part by the Department of the Navy and managed by the Office of the Chief of Naval Research under Gra_at N00014-91-:I-1283. tPh. (217) 244-7180, Fax (217) 244-5686, emaih mouradQcrhc.uiuc.edu